BEGIN

EXECUTE IMMEDIATE 
'ALTER TABLE
    %TABLE_NAME%
ADD (
    %PREFIX%id number,
    %PREFIX%created timestamp
)';


EXECUTE IMMEDIATE   
'UPDATE
    %TABLE_NAME%
SET
    %PREFIX%id = %SEQUENCE_NAME%.nextval,
    %PREFIX%created = SYSDATE';


EXECUTE IMMEDIATE 
'ALTER TABLE
    %TABLE_NAME%
MODIFY (
    %PREFIX%id NOT NULL,
    %PREFIX%created NOT NULL
)';

END;
